CREATE TABLE [dbo].[ScheduledTask]
(
[ScheduledTaskKey] [uniqueidentifier] NOT NULL,
[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RunAsUserKey] [uniqueidentifier] NULL,
[SingleInstanceConcurrency] [bit] NOT NULL CONSTRAINT [DF_ScheduledTask_SingleInstanceConcurrency] DEFAULT ((0)),
[Schedule] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsDisabled] [bit] NOT NULL CONSTRAINT [DF_ScheduledTask_IsDisabled] DEFAULT ((0)),
[Category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SelectionLock] [uniqueidentifier] NULL,
[KeepAlive] [datetime] NULL,
[MostRecentRun] [datetime] NULL,
[MostRecentWorkflowInstanceKey] [uniqueidentifier] NULL,
[AtomKey] [uniqueidentifier] NULL,
[AtomGraph] [image] NULL,
[CreatedByUserKey] [uniqueidentifier] NULL,
[CreatedOn] [datetime] NULL,
[UpdatedByUserKey] [uniqueidentifier] NULL,
[UpdatedOn] [datetime] NULL,
[WorkflowInputParameters] [image] NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[ScheduledTask] ADD CONSTRAINT [PK_ScheduledTask] PRIMARY KEY CLUSTERED ([ScheduledTaskKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ScheduledTask_CreatedByUserKey] ON [dbo].[ScheduledTask] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ScheduledTask_RunAsUserKey] ON [dbo].[ScheduledTask] ([RunAsUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ScheduledTask_SelectionLock] ON [dbo].[ScheduledTask] ([SelectionLock]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ScheduledTask_UpdatedByUserKey] ON [dbo].[ScheduledTask] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScheduledTask] ADD CONSTRAINT [FK_ScheduledTask_ScheduledTaskService] FOREIGN KEY ([SelectionLock]) REFERENCES [dbo].[ScheduledTaskService] ([ScheduledTaskServiceKey])
GO
ALTER TABLE [dbo].[ScheduledTask] ADD CONSTRAINT [FK_ScheduledTask_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[ScheduledTask] ADD CONSTRAINT [FK_ScheduledTask_UserMain_RunAs] FOREIGN KEY ([RunAsUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[ScheduledTask] ADD CONSTRAINT [FK_ScheduledTask_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO